Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. Phys.='Yes' and year='2010-2011' and pbres_id='7'' at line 1

select COUNT(*) AS numrows from pu_research_pub where pub_status='Active' and Chin. J. Chem. Phys.='Yes' and year='2010-2011' and pbres_id='7'